Add a Database Instance

You can use the Database Manager to add one or more database instances to a server that already has a ClearSCADA server installed. The ClearSCADA server that was first installed on the server is the 'original' or 'default' ClearSCADA database server, and every ClearSCADA database server that you add subsequently is a database instance. A database instance can run, and be configured, in the same way as any other ClearSCADA server. (If you are unfamiliar with the concept of database instances, see Running Multiple ClearSCADA Servers on a Single Machine).

To add a database instance:

1. Display the Database Manager
2. Select the Add button to display the Add Database Server window.

   

3. Define a unique Name for the new database instance.
4.  Enter the number of the TCP/IP Port that the new database instance will monitor for incoming connections. You should choose a TCP/IP port that is not already being used by other database instances (including the original ClearSCADA database server).

   NOTE: If multiple servers are set to use the same port, the first server to start will use the port. The other servers will be unable to use the port and so will fail on startup.

   This is important if you intend to create a set of permanent standby servers on a single system, for example as an offline test configuration.

5. If you want the new database instance to run automatically when Windows starts, select the Register as Service check box. When the database instance is registered as a Windows service, it runs on Windows startup and you can also start and stop it manually from the Windows Control Panel.

   If you do not register the database instance as a Windows service, you will need to use a command line argument or the server icon to run the server (see Start a Database Instance Manually).

6. If you want to add a server icon for the database instance, select the Run ServerIcon on Startup check box. The server icon will be shown in the Windows system tray at startup, alongside the server icons for any other database instances and the original ClearSCADA server. The server icon provides quick access to various server features,including the Server Status Tool, Server Configuration Tool, and database log file.

   If you decide that you do not want a server icon for the database instance,clear the Run ServerIcon on Startup check box. As the server icon will not run automatically, you will need to use a command line to run it when you need to use its features (see Run the Server Icon for a Database Instance).

7. Use the Database Directory field to define where the database for the new database instance will be stored. You can either enter the location of the database manually, or you can use the Browse button to navigate to the required location.

   ATTENTION:To avoid one server overwriting the database of another, you need to choose a location that is not already used by another database instance.

8. Use the Log File Directory field to define where the log file for the new database instance will be stored. Again, you can enter the location manually or use the Browse button and the location you choose should not be used by another database instance.

9. Select the Add button to confirm your selections and create the new database instance. Alternatively, you can select Cancel to close the Add Database Server window without creating the database instance.

You have now added a ClearSCADA database instance and it is listed on the Database Manager window.

After adding a ClearSCADA database instance, you will need to:

1. For each client that you want to connect to the new database instance, you need to configure a Client Connection. The connection should be set up in the same way as any other client - ClearSCADA connection seeCreate a New ViewX Client to System Connection in the ClearSCADA Guide to Client Administration.
2. Use the Server Icon for the database instance to access the various server configuration features, including the License Details and the Server Configuration Tool.For information about running the Server Icon application, see Run the Server Icon for a Database Instance

   NOTE: If you have created multiple (instances) servers on one system and you have multiple Server Icons you can use any of the icons to access the Server Configuration Tool.

3. Configure the server settings for the new database instance in the same way as you would configure any other ClearSCADA server. For details on how to configure the server settings, please refer to the ClearSCADA Guide to Server Administration (see Welcome to the Server Administration Guide).